About

The tech industry has experienced unprecedented growth in the recent decade, revolutionizing the way we live and work. Moreover, the rapid advancements in technology has created compelling investment opportunities, attracting investors to seek additional income from the stock market.

The Big Tech Stock Prices dashboard intends to provide a summary of the past stock performance for 14 big tech companies. It also enables the user to compare between the stocks and use the moving average indicator to further analyze the price trend.

The data set is obtained from the package tidytuesday from week 2023-02-07 and is originated from the Kaggle data set Big Tech Stock Prices. Please see The Data tab for more details.

The Data

The stock data for this dashboard is from the package tidytuesday from week 2023-02-07 and is originated from the Kaggle data set Big Tech Stock Prices. It contains the stock prices for 14 big tech companies from 2010/01 to 2023/01, and the data for different companies cover slightly different time ranges. To keep data consistent among companies, entries in the common range from 2012-07-01 to 2022-12-31 are used.

The data dictionary for the two files in the dataset is recreated below.

big_tech_stock_prices.csv

variable	class	description
stock_symbol	character	stock symbol
date	double	date
open	double	The price at market open.
high	double	The highest price for that day.
low	double	The lowest price for that day.
close	double	The price at market close, adjusted for splits.
adj_close	double	The closing price after adjustments for all applicable splits and dividend distributions. Data is adjusted using appropriate split and dividend multipliers, adhering to Center for Research in Security Prices (CRSP) standards.
volume	double	The number of shares trated on that day.

big_tech_companies.csv

variable	class	description
stock_symbol	character	stock symbol
company	character	Full name of the company.

Below is the stock data combined from the two raw files.

check the start and end year for each stock

static 1 - sub tab (by quarter and by year) plot overall increase/decrease in price (percentage), and average daily volume

static 2 - table summarizing the recent growth for each companies (recent year)

interactive 1 - compare two stocks (price and volumn), change date, select companies, whether fix scale

interactive 2 - select one company, draw moving averages (select the averaging period)

analysis -

Past Performance Summary

Historical Returns

Compare Stocks

Chart

Draft